SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_UpdatePortalAliasOnInstall
	@PortalAlias			nvarchar(200),
	@LastModifiedByUserID	int
AS
	UPDATE dbo.DnnProduct_PortalAlias 
		SET HTTPAlias = @PortalAlias,
			LastModifiedByUserID = @LastModifiedByUserID,
			LastModifiedOnDate = getdate()
	WHERE  HTTPAlias = '_default'
GO
